﻿CREATE TABLE [dbo].[TIEMNANG] (
    [IdDoiTuong]       UNIQUEIDENTIFIER NOT NULL,
    [MaHieu]           NCHAR (100)      NOT NULL,
    [XungHo]           NCHAR (100)      NULL,
    [HoVaDem]          NCHAR (100)      NULL,
    [Ten]              NCHAR (100)      NULL,
    [HoVaTen]          NCHAR (100)      NOT NULL,
    [CongTy]           NCHAR (100)      NOT NULL,
    [ChucDanh]         NCHAR (100)      NULL,
    [TelCQ]            CHAR (20)        NULL,
    [TelNR]            CHAR (20)        NULL,
    [TelKhac]          CHAR (20)        NULL,
    [Mobile]           CHAR (20)        NULL,
    [MobileKhac]       CHAR (20)        NULL,
    [Fax]              CHAR (20)        NULL,
    [Email]            CHAR (100)       NULL,
    [Website]          NCHAR (100)      NULL,
    [LinhVuc]          INT              NULL,
    [PhongBan]         NCHAR (100)      NULL,
    [SLNhanVien]       NCHAR (100)      NULL,
    [DoanhThuNam]      NCHAR (100)      NULL,
    [NguonGoc]         NCHAR (100)      NULL,
    [TinhTrang]        NCHAR (100)      NOT NULL,
    [DanhGia]          NVARCHAR (20)    NULL,
    [DienGiai]         NVARCHAR (MAX)   NULL,
    [KoEmail]          BIT              NOT NULL,
    [IdDiaChiCoQuan]   INT              NULL,
    [IdDiaChiNhaRieng] INT              NULL
);



